package com.leetroll.common.constant;

/**
 * SQL字段常量
 */
public class BaseSQLConstant {

    public final static String ID = "id";
    public final static String IP = "ip";
    public final static String NAME = "name";
    public final static String STATUS = "status";

    /**
     * user表
     */
    public static final String URL = "url";
    public final static String PHONE = "phone";
    public static final String USER_OPENID = "openid";

    /**
     * sys_config表
     */
    public final static String SYS_CONFIG_KEY = "key";
    public final static String SYS_CONFIG_VALUE = "value";


    /**
     * item表
     */
    public final static String ITEM_NAME = "name";
    public final static String ITEM_TYPE = "type";
    public final static String ITEM_PRICE = "price";
    public final static String ITEM_AUTHOR = "author";
    public final static String ITEM_CAT_ID = "cat_id";
    public final static String ITEM_STATUS = "status";

    /**
     * file表
     */
    public final static String FILE_RESC_ID = "resc_id";
    public final static String FILE_TYPE = "type";


    /**
     * order表
     */
    public final static String ORDER_BATCH_CODE = "batch_code";
    public final static String ORDER_STATUS = "status";


    /**
     * order_detail表
     */
    public final static String ORDER_ID = "order_id";

    /**
     * user_action表
     */
    public final static String ACTION_ACTION = "action";
    public final static String ACTION_VALUE = "value";


    /**
     * issue表
     */
    public final static String ISSUE_TITLE = "title";
    public final static String ISSUE_CONTENT = "content";
    public final static String ISSUE_SUBJECT = "subject";

    /**
     * comment表
     */
    public final static String RESC_TYPE = "resc_type";
    public final static String RESC_ID = "resc_id";


    public final static String USER_ID = "user_id";
    public final static String ITEM_ID = "item_id";
    public final static String CHAPTER_ID = "chapter_id";
}
